package com.project_doctor.mapper;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.project_doctor.pojo.Service;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
* @author xixif
* @description 针对表【t_service(服务项目表)】的数据库操作Mapper
* @createDate 2025-06-16 16:39:18
* @Entity com.project_doctor.pojo.Service
*/
public interface ServiceMapper extends BaseMapper<Service> {
    @Select("SELECT s.id id,s.name name,times ,t.name type,price,description FROM t_service s LEFT JOIN t_service_type t ON s.type = t.id  ${ew.customSqlSegment}")
    Page<Service> selectPageService(Page<Service> page,@Param(Constants.WRAPPER) QueryWrapper<Service> lambda);
}




